<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org">
<head>
    <base th:href="@{/}">
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon">
    <title></title>
</head>
<body>
<!--管理员：查询统计报表交互界面-->
<div class="easyui-tabs" style="width:100%;height:100%">
    <div title="单科最高分" style="padding:2px">
        <table id="dg_singlemax" style="width:100%;height:100%">
        </table>
        <div id="singlemax_toolbar">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="singlemax_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;" >
                        <select id="singlemax_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="singlemax_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="singlemax_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search"  style="margin: 30px 0 0 30px;" onclick="doQueSingleMax()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportSingleMax()">导出当前页</a>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div title="上线情况" style="padding:10px">
        <table id="dg_passinform" style="width:100%;height:100%">
        </table>
        <div id="passinform_toolbar">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="passinform_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="passinform_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="passinform_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="passinform_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" style="margin: 30px 0 0 30px;" onclick="doQuePassInform()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportPassInform()">导出当前页</a>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div title="班级学科平均分" style="padding:10px">
        <table id="dg_teamcourseave" style="width:100%;height:100%">
        </table>
        <div id="teamcourseave_toolbar">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="teamcourseave_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="teamcourseave_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="teamcourseave_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="teamcourseave_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" style="margin: 30px 0 0 30px;" onclick="doQueTeamCourseAve()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportTeamCourseAve()">导出当前页</a>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div title="班级学科中位数" style="padding:10px">
        <table id="dg_teamcoursemedian" style="width:100%;height:100%">
        </table>
        <div id="teamcoursemedian_toolbar">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="teamcoursemedian_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="teamcoursemedian_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="teamcoursemedian_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="teamcoursemedian_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" style="margin: 30px 0 0 30px;" onclick="doQueTeamCourseMedian()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportTeamCourseMedian()">导出当前页</a>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div title="班级学科四率" style="padding:10px">
        <table id="dg_teamcourserate" style="width:100%;height:100%">
        </table>
        <div id="teamcourserate_toolbar">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="teamcourserate_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px">
                        <select id="teamcourserate_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="teamcourserate_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="teamcourserate_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td>
                        <select id="teamcourserate_courseEnName" class="easyui-combobox" name="courseEnName" label="选择学科:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="course:${session.courses}" th:value="${course.getCourseEnName()}" th:text="${course.getCourseChName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" style="margin: 30px 0 0 30px;" onclick="doQueTeamCourseRate()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportTeamCourseRate()">导出当前页</a>
                    </td>
                </tr>
            </table>
        </div>
    </div>
    <div title="班级总分一分段" style="padding:10px">
        <table id="dg_totaldivide" style="width:100%;height:100%">
        </table>
        <div id="totaldivide_toolbar">
            <form id="exportTotalDivideId" action="exportTotalDivideData" method="post">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="totaldivide_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="totaldivide_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="totaldivide_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="totaldivide_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" style="margin: 30px 0 0 30px;" onclick="doQueTotalDivide()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportTotalDivide()">导出</a>
                    </td>
                </tr>
            </table>
            </form>
        </div>
    </div>
    <div title="班级学科一分段" style="padding:10px">
        <table id="dg_coursedivide" style="width:100%;height:100%">
        </table>
        <div id="coursedivide_toolbar">
            <form id="exportCourseDivideId" action="exportCourseDivideData" method="post">
            <table>
                <tr>
                    <td style="width: 120px;">
                        <select id="coursedivide_gradeName" class="easyui-combobox" name="gradeName" label="选择年级:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="gra:${session.grades}" th:value="${gra.getGradeName()}" th:text="${gra.getGradeName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="coursedivide_semesterName" class="easyui-combobox" name="semesterName" label="选择学期:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="semes:${session.semesters}" th:value="${semes.getSemesterName()}" th:text="${semes.getSemesterName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 300px;">
                        <select id="coursedivide_examName" class="easyui-combobox" name="examName" label="选择考试:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="exa:${session.exams}" th:value="${exa.getExamName()}" th:text="${exa.getExamName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 120px;">
                        <select id="coursedivide_categoryName" class="easyui-combobox" name="categoryName" label="选择分类:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="cate:${session.categorys}" th:value="${cate.getCategoryName()}" th:text="${cate.getCategoryName()}"></option>
                        </select>
                    </td>
                    <td style="width: 10px;"></td>
                    <td style="width: 60px;">
                        <select id="coursedivide_courseEnName" class="easyui-combobox" name="courseEnName" label="选择学科:" labelPosition="top" data-options="editable:false" style="width:100%;">
                            <option th:each="course:${session.courses}" th:value="${course.getCourseEnName()}" th:text="${course.getCourseChName()}"></option>
                        </select>
                    </td>
                    <td style="width: 300px;">
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-search" style="margin: 30px 0 0 30px;" onclick="doQueCourseDivide()">查询</a>
                        <a href="javascript:void(0)" class="easyui-linkbutton" iconCls="icon-export"  style="margin: 30px 0 0 30px;" onclick="doExportCourseDivide()">导出</a>
                    </td>
                </tr>
            </table>
            </form>
        </div>
    </div>
</div>

<script type="text/javascript" th:inline="none">
    $(function () {
        //分页参数
        let pageParam = {
            pageSize: 30,							//每页显示的记录条数，默认为10
            pageList: [30, 50, 100, 150, 2000],	//可以设置每页记录条数的列表
            beforePageText: '第',				//页数文本框前显示的汉字
            afterPageText: '页    共 {pages} 页',
            displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录',
        }
        //单科最高分显示
        $("#dg_singlemax").datagrid({
            url: "getQueSingleMax",
            queryParams:{
                semesterName: $("#singlemax_semesterName").val(),
                gradeName:$("#singlemax_gradeName").val(),
                examName: $("#singlemax_examName").val(),
                categoryName: $("#singlemax_categoryName").val()
            },
            toolbar: "#singlemax_toolbar",
            pagination: true,
            pageSize: 30,
            rownumbers: true,
            fitColumns: true,
            singleSelect: false,
            fit: true,
            columns: [[
                {field: 'courseChName', title: '学科名称', align:'center', width: 50, sortable: true},
                {field: 'studentNames', title: '学生姓名',align:'center', width: 50},
                {field: 'teamNames', title: '班级名称', align:'center',width: 50},
                {field: 'result', title: '分数', align:'center',width: 30},
                {field: 'teacherNames', title: '教师姓名',align:'center', width: 50}
            ]]
        });
        let pageSingleMax = $("#dg_singlemax").datagrid("getPager");
        $(pageSingleMax).pagination(pageParam);
        //上线情况显示
        $("#dg_passinform").datagrid({
            url: "getQuePassInform",
            queryParams:{
                semesterName: $("#passinform_semesterName").val(),
                gradeName:$("#passinform_gradeName").val(),
                examName: $("#passinform_examName").val(),
                categoryName: $("#passinform_categoryName").val()
            },
            toolbar: "#passinform_toolbar",
            pagination: true,
            pageSize: 30,
            rownumbers: true,
            fitColumns: true,
            singleSelect: false,
            fit: true,
            columns: [[
                {field: 'teamName', title: '班级名称', align:'center', width: 50, sortable: true},
                {field: 'studentNumber', title: '实考人数',align:'center', width: 50},
                {field: 'onePass', title: '重本（或联招）上线人数', align:'center',width: 50},
                {field: 'twoPass', title: '本科（或普招）上线人数', align:'center',width: 50}
            ]]
        });
        let pagePassInform = $("#dg_passinform").datagrid("getPager");
        $(pagePassInform).pagination(pageParam);
        //班级学科平均分显示
        $("#dg_teamcourseave").datagrid({
            url: "getQueTeamCourseAve",
            queryParams:{
                semesterName: $("#teamcourseave_semesterName").val(),
                gradeName:$("#teamcourseave_gradeName").val(),
                examName: $("#teamcourseave_examName").val(),
                categoryName: $("#teamcourseave_categoryName").val()
            },
            toolbar: "#teamcourseave_toolbar",
            pagination: true,
            pageSize: 30,
            rownumbers: true,
            fitColumns: true,
            singleSelect: false,
            fit: true,
            columns: [[
                {field: 'teamName', title: '班级名称', align:'center', width: 30, sortable: true},
                {field: 'studentNumber', title: '实考人数',align:'center', width: 30},
                {field: 'totalAve', title: '总分平均分', align:'center',width: 30},
                {field: 'chineseAve', title: '语文平均分', align:'center',width: 30},
                {field: 'mathsAve', title: '数学平均分', align:'center',width: 30},
                {field: 'englishAve', title: '英语平均分', align:'center',width: 30},
                {field: 'physicsAve', title: '物理平均分', align:'center',width: 30},
                {field: 'historyAve', title: '历史平均分', align:'center',width: 30},
                {field: 'chemistryAve', title: '化学平均分', align:'center',width: 30},
                {field: 'geographyAve', title: '地理平均分', align:'center',width: 30},
                {field: 'politicsAve', title: '政治平均分', align:'center',width: 30},
                {field: 'biologyAve', title: '生物平均分', align:'center',width: 30},
                {field: 'sportsAve', title: '体育平均分', align:'center',width: 30}
            ]]
        });
        let pageTeamCourseAve = $("#dg_teamcourseave").datagrid("getPager");
        $(pageTeamCourseAve).pagination(pageParam);
        // 班级学科中位数显示
        $("#dg_teamcoursemedian").datagrid({
        url: "getQueTeamCourseMedian",
        queryParams:{
                semesterName: $("#teamcoursemedian_semesterName").val(),
                gradeName:$("#teamcoursemedian_gradeName").val(),
                examName: $("#teamcoursemedian_examName").val(),
                categoryName: $("#teamcoursemedian_categoryName").val()
            },
        toolbar: "#teamcoursemedian_toolbar",
        pagination: true,
        pageSize: 30,
        rownumbers: true,
        fitColumns: true,
        singleSelect: false,
        fit: true,
        columns: [[
            {field: 'teamName', title: '班级名称', align:'center', width: 50, sortable: true},
            {field: 'studentNumber', title: '实考人数',align:'center', width: 30},
            {field: 'totalAve', title: '总分平均分', align:'center',width: 30},
            {field: 'chineseMedian', title: '语文中位数', align:'center',width: 30},
            {field: 'mathsMedian', title: '数学中位数', align:'center',width: 30},
            {field: 'englishMedian', title: '英语中位数', align:'center',width: 30},
            {field: 'physicsMedian', title: '物理中位数', align:'center',width: 30},
            {field: 'historyMedian', title: '历史中位数', align:'center',width: 30},
            {field: 'chemistryMedian', title: '化学中位数', align:'center',width: 30},
            {field: 'geographyMedian', title: '地理中位数', align:'center',width: 30},
            {field: 'politicsMedian', title: '政治中位数', align:'center',width: 30},
            {field: 'biologyMedian', title: '生物中位数', align:'center',width: 30},
            {field: 'sportsMedian', title: '体育中位数', align:'center',width: 30}
        ]]
        });
        let pageTeamCourseMedian = $("#dg_teamcoursemedian").datagrid("getPager");
        $(pageTeamCourseMedian).pagination(pageParam);
        //班级学科四率显示
        $("#dg_teamcourserate").datagrid({
            url: "getQueTeamCourseRate",
            queryParams:{
                semesterName: $("#teamcourserate_semesterName").val(),
                gradeName:$("#teamcourserate_gradeName").val(),
                examName: $("#teamcourserate_examName").val(),
                categoryName: $("#teamcourserate_categoryName").val(),
                courseEnName:$("#teamcourserate_courseEnName").val()
            },
            toolbar: "#teamcourserate_toolbar",
            pagination: true,
            pageSize: 30,
            rownumbers: true,
            fitColumns: true,
            singleSelect: false,
            fit: true,
            columns: [[
                {field: 'courseChName', title: '学科名称', align:'center', width: 30, sortable: true},
                {field: 'totalStudentNumber', title: '年级实考人数',align:'center', width: 30},
                {field: 'totalBadRate', title: '年级差生率', align:'center',width: 30},
                {field: 'totalGoodRate', title: '年级及格率', align:'center',width: 30},
                {field: 'totalBetterRate', title: '年级良好率', align:'center',width: 30},
                {field: 'totalBestRate', title: '年级优生率', align:'center',width: 30},
                {field: 'teamName', title: '班级名称', align:'center', width: 30},
                {field: 'teamStudentNumber', title: '班级实考人数',align:'center', width: 30},
                {field: 'teamBadRate', title: '班级差生率', align:'center',width: 30},
                {field: 'teamGoodRate', title: '班级及格率', align:'center',width: 30},
                {field: 'teamBetterRate', title: '班级良好率', align:'center',width: 30},
                {field: 'teamBestRate', title: '班级优生率', align:'center',width: 30},
            ]]
        });
        let pageTeamCourseRate = $("#dg_teamcourserate").datagrid("getPager");
        $(pageTeamCourseRate).pagination(pageParam);
        //班级总分一分段显示
        $("#dg_totaldivide").datagrid({
            url: "getQueTotalDivide",
            queryParams:{
                semesterName: $("#totaldivide_semesterName").val(),
                gradeName:$("#totaldivide_gradeName").val(),
                examName: $("#totaldivide_examName").val(),
                categoryName: $("#totaldivide_categoryName").val()
            },
            toolbar: "#totaldivide_toolbar",
            pagination: true,
            pageSize: 30,
            rownumbers: true,
            fitColumns: true,
            singleSelect: false,
            fit: true,
            columns: [[
                {field: 'totalDivide', title: '总分一分段', align:'center', width: 30, sortable: true},
                {field: 'totalStudentNumber', title: '总人数', align:'center', width: 30},
                {field: 'teamName', title: '班级名称', align:'center', width: 30, sortable: true},
                {field: 'teamStudentNumber', title: '班级人数', align:'center', width: 30}
            ]]
        });
        let pageTotalDivide = $("#dg_totaldivide").datagrid("getPager");
        $(pageTotalDivide).pagination(pageParam);
        //班级学科一分段显示
        $("#dg_coursedivide").datagrid({
            url: "getQueCourseDivide",
            queryParams:{
                semesterName: $("#coursedivide_semesterName").val(),
                gradeName:$("#coursedivide_gradeName").val(),
                examName: $("#coursedivide_examName").val(),
                categoryName: $("#coursedivide_categoryName").val(),
                courseEnName: $("#coursedivide_courseEnName").val()
            },
            toolbar: "#coursedivide_toolbar",
            pagination: true,
            pageSize: 30,
            rownumbers: true,
            fitColumns: true,
            singleSelect: false,
            fit: true,
            columns: [[
                {field: 'courseChName', title: '学科名称', align:'center', width: 30},
                {field: 'courseDivide', title: '学科一分段', align:'center', width: 30},
                {field: 'totalCourseStudentNumber', title: '年级人数', align:'center', width: 30},
                {field: 'teamName', title: '班级名称', align:'center', width: 30, sortable: true},
                {field: 'teamCourseStudentNumber', title: '班级人数', align:'center', width: 30}
            ]]
        });
        let pageCourseDivide = $("#dg_coursedivide").datagrid("getPager");
        $(pageCourseDivide).pagination(pageParam);
    });
    // 按所选条件搜索单科最高分
    function doQueSingleMax(){
                $("#dg_singlemax").datagrid("load", {
                    "semesterName": $("#singlemax_semesterName").val(),
                    "gradeName":$("#singlemax_gradeName").val(),
                    "examName": $("#singlemax_examName").val(),
                    "categoryName": $("#singlemax_categoryName").val()
                });
    }
    // 导出单科最高分
    function doExportSingleMax(){
        let t=$("#singlemax_examName").val();
        $('#dg_singlemax').datagrid('toExcel', {
            filename: t+'单科最高分.xls',
            worksheet: t+'单科最高分'
        });
    }
    // 按条件搜索上线情况
    function doQuePassInform(){
        $("#dg_passinform").datagrid("load", {
            "semesterName": $("#passinform_semesterName").val(),
            "gradeName":$("#passinform_gradeName").val(),
            "examName": $("#passinform_examName").val(),
            "categoryName": $("#passinform_categoryName").val()
        });
    }
    // 导出上线情况
    function doExportPassInform(){
        $('#dg_passinform').datagrid('toExcel', {
            filename: $("#passinform_examName").val()+'上线情况.xls',
            worksheet: $("#passinform_examName").val()+'上线情况'
        });
    }
    // 按条件搜索班级学科平均分
    function doQueTeamCourseAve(){
            $("#dg_teamcourseave").datagrid("load", {
                "semesterName": $("#teamcourseave_semesterName").val(),
                "gradeName": $("#teamcourseave_gradeName").val(),
                "examName": $("#teamcourseave_examName").val(),
                "categoryName": $("#teamcourseave_categoryName").val()
            });
    }
    // 导出班级学科平均分
    function doExportTeamCourseAve(){
        $('#dg_teamcourseave').datagrid('toExcel', {
            filename: $("#teamcourseave_examName").val()+'班级学科平均分.xls',
            worksheet: $("#teamcourseave_examName").val()+'班级学科平均分'
        });
    }
    // 按条件搜索班级学科中位数
    function doQueTeamCourseMedian(){
            $("#dg_teamcoursemedian").datagrid("load", {
                "semesterName": $("#teamcoursemedian_semesterName").val(),
                "gradeName": $("#teamcoursemedian_gradeName").val(),
                "examName": $("#teamcoursemedian_examName").val(),
                "categoryName": $("#teamcoursemedian_categoryName").val()
            });
    }
    // 导出班级学科中位数
    function doExportTeamCourseMedian(){
        $('#dg_teamcoursemedian').datagrid('toExcel', {
            filename: $("#dg_teamcoursemedian").val()+'班级学科中位数.xls',
            worksheet: $("#dg_teamcoursemedian").val()+'班级学科中位数'
        });
    }
    // 按条件搜索班级学科四率
    function doQueTeamCourseRate(){
            $("#dg_teamcourserate").datagrid("load", {
                "semesterName": $("#teamcourserate_semesterName").val(),
                "gradeName": $("#teamcourserate_gradeName").val(),
                "examName": $("#teamcourserate_examName").val(),
                "categoryName": $("#teamcourserate_categoryName").val(),
                "courseEnName": $("#teamcourserate_courseEnName").val()
            });
    }
    // 导出班级学科四率
    function doExportTeamCourseRate(){
        $('#dg_teamcourserate').datagrid('toExcel', {
            filename: $("#teamcourserate_examName").val()+'班级学科四率.xls',
            worksheet: $("#teamcourserate_examName").val()+'班级学科四率'
        });
    }
    //按条件搜索班级总分一分段
    function doQueTotalDivide(){
            $("#dg_totaldivide").datagrid("load", {
                "semesterName": $("#totaldivide_semesterName").val(),
                "gradeName": $("#totaldivide_gradeName").val(),
                "examName": $("#totaldivide_examName").val(),
                "categoryName": $("#totaldivide_categoryName").val()
            });
    }
    // 导出班级总分一分段
    function doExportTotalDivide(){
        $("#exportTotalDivideId").submit();
    }
    //按条件搜索班级学科一分段
    function doQueCourseDivide(){
            $("#dg_coursedivide").datagrid("load", {
                "semesterName": $("#coursedivide_semesterName").val(),
                "gradeName": $("#coursedivide_gradeName").val(),
                "examName": $("#coursedivide_examName").val(),
                "categoryName": $("#coursedivide_categoryName").val(),
                "courseEnName": $("#coursedivide_courseEnName").val()
            });
    }
    // 导出班级学科一分段
    function doExportCourseDivide(){
        $("#exportCourseDivideId").submit();
    }
</script>
</body>
</html>